How to: Copy data within a table.
Solution:
Open the Table Datasheet view, select and copy an entry or part of an entry, and paste it to a new location within the same table.
1) If the Database window is not active, activate the Database window.
2) Open the Table Datasheet view.
3) Do one of the following to select what will be copied:
a) To copy an entire cell entry, select only that cell. (The cell is highlighted.)
Entire cell selected
b) To copy part of a cell entry, select (highlight) only the portion of the entry to be copied by clicking and dragging the mouse over it.
Part of cell entry selected
4) Select the 'Edit' menu and select 'Copy'. (The selected information is copied to the Clipboard but is not deleted from the datasheet.)
5) Move the cursor to where the copied data is to be pasted.
NOTE: If an entire cell was selected in step 3), select an entire cell to which to paste the data.
6) Select the 'Edit' menu and select 'Paste'.
7) Select the 'File' menu and select 'Save' to save changes.
8) Select the 'File' menu and select 'Close' to close the Table Datasheet view. (The Table Datasheet view closes, and changes are saved automatically if not already saved.)
